UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1rLaQvieynrxMH1zLD4dkU7j9J6oowcnAYqxS9TUTLM='
WHERE
key_id = 'c78ebee60186a2a94ce708b75d610a978848c12d3107427865b5fac084ead02e'
AND (
token = '1rLaQvieynrxMH1zLD4dkU7j9J6oowcnAYqxS9TUTLM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)