UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XIoLZQFAjALj10fO20yPpXk0diiUUt0x09dozkLINCY='
WHERE
key_id = '34795512bbfdaeab0169a0c0ad89a0076b5e59ff868ef46148b1ce58fa9524fa'
AND (
token = 'XIoLZQFAjALj10fO20yPpXk0diiUUt0x09dozkLINCY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)