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