UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8dMvkjLP5l5Lun9iqcla8gk0UwFcoPNBpNqPwVpTatE='
WHERE
key_id = '27c57d7bc85d114526d94cec3f7433b69e111dacfef4609a83810bb0ff052425'
AND (
token = '8dMvkjLP5l5Lun9iqcla8gk0UwFcoPNBpNqPwVpTatE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)