UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CRV16d14pECzPjpVBkUmeVj0eLSGTpVK0GM668Bpmh0='
WHERE
key_id = '3a945ca8a6a23f9ad816d9d7f23dd9de2906f774c32053104ea6a0a7ca9349ca'
AND (
token = 'CRV16d14pECzPjpVBkUmeVj0eLSGTpVK0GM668Bpmh0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)