UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XsUG/QA91HKvV+BpfJoQGgsLDr0gjiCn5jrEqYzW8G8='
WHERE
key_id = 'd9ff8ca828b81f019c6fd60045cce223ddd8296b70ba12cc2218cc03c23eb14f'
AND (
token = 'XsUG/QA91HKvV+BpfJoQGgsLDr0gjiCn5jrEqYzW8G8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)