UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CXrQi7XjDB8CnqLYayKqxn9R5QBUnatEzOUoRD4hKiM='
WHERE
key_id = '94db2dbf1f948df3ca9469417fb027b710f5197ff7e9be732ac6c32073365739'
AND (
token = 'CXrQi7XjDB8CnqLYayKqxn9R5QBUnatEzOUoRD4hKiM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)