UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fRgzZNxH/UKAcPxcJeBJdWGpifs9NiaHBFOgIyhhFjg='
WHERE
key_id = 'ccda19f3813fe6c7982873009821b6d8f4282a84fd1747b8567ec6bde465afea'
AND (
token = 'fRgzZNxH/UKAcPxcJeBJdWGpifs9NiaHBFOgIyhhFjg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)