UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CcMJM/drlQknmkmhN70joCKh5gWZ9QtIygBSlEY8Hhk='
WHERE
key_id = 'a80eef4b17e756369a0d87f9c22005a15b4af654b333c78978c2a304a2a9bdfb'
AND (
token = 'CcMJM/drlQknmkmhN70joCKh5gWZ9QtIygBSlEY8Hhk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)