UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZfX+6EP6zV/RF6LII6z0YlXHEEIwTTTS+rOd/B91Iys='
WHERE
key_id = 'a63b3b4072d0d9c0fea69efe69b3b19a0a57dcd37aee8afb0d40b5a19e79d279'
AND (
token = 'ZfX+6EP6zV/RF6LII6z0YlXHEEIwTTTS+rOd/B91Iys='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)