UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BTkXJFoFJjIqCIhqs1dvznJnhEaGg0gPN9ZNag6jZp0='
WHERE
key_id = '8f3d492777ffd5e192d090e544afc8fa6ec496be1832fbfb689de950df4c28ff'
AND (
token = 'BTkXJFoFJjIqCIhqs1dvznJnhEaGg0gPN9ZNag6jZp0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)