UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2xLGEyPL0N1qokv0R1qBUm3j/z+9q0AaL36PqDV8Zgw='
WHERE
key_id = '64a324c11cd38e978f7b0982a34a518b15b1353e0158aa75e854235f92ff9df4'
AND (
token = '2xLGEyPL0N1qokv0R1qBUm3j/z+9q0AaL36PqDV8Zgw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)