UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Si7zeVSJfRfAz+t+aeom4nyBAp6LEPfniJzc8gaiJH0='
WHERE
key_id = 'e23404e3738f9f32a0bacc86eb4bace89c768920b6d7e0ffc3015077af3bda9b'
AND (
token = 'Si7zeVSJfRfAz+t+aeom4nyBAp6LEPfniJzc8gaiJH0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)