UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HZjjwaOpw0RQlvkhiWxdfy8HZoS3weEZn7aFSYFSbBY='
WHERE
key_id = 'fb6cc09286e262ac8a163ee63df86a185eacbb230297194566cc045705c0b77a'
AND (
token = 'HZjjwaOpw0RQlvkhiWxdfy8HZoS3weEZn7aFSYFSbBY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)