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