UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Z24fFstFqLM/2NsiOcH2MSCPrX/DRy9YJMhU9+aMDmU='
WHERE
key_id = '49b2fa05421af9d63c4a55765e8785886ac1435d15f320da79ec7565335b46f5'
AND (
token = 'Z24fFstFqLM/2NsiOcH2MSCPrX/DRy9YJMhU9+aMDmU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)