UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZyVe5ORJWkNfHvtJfu9fUBf259v3peRiofIUD/Vxkz0='
WHERE
key_id = 'b7765e08dca5a3b19e2f3201be41771bac2bdd60770a93f26f5b1b34556fc6ed'
AND (
token = 'ZyVe5ORJWkNfHvtJfu9fUBf259v3peRiofIUD/Vxkz0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)