UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VvIJBufoR8n2eCVBSIVWLE9LMJVmjinXeWMALjNRSK8='
WHERE
key_id = 'fe3b28f6895fab9f6a9b868fe00a14c5c63acbf74d3542dd403427a2d03bf321'
AND (
token = 'VvIJBufoR8n2eCVBSIVWLE9LMJVmjinXeWMALjNRSK8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)