UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GceAtF1zvJ6hZW7t32+nCMDZ0USUeZt8keSWWT0OAzo='
WHERE
key_id = 'f9bf5bab245ef2ea116fc2a2c0fb34adaa9c75f870d18c6808b051a1fe524b8a'
AND (
token = 'GceAtF1zvJ6hZW7t32+nCMDZ0USUeZt8keSWWT0OAzo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)