UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MnfaIrTnF5CSCuaR/O6gUYmu936osmZlwtmA3FQRAzA='
WHERE
key_id = '5a0a438733ac9012cf39a554fc59a3ed993165a59514168f3c7a3c292c0fd90e'
AND (
token = 'MnfaIrTnF5CSCuaR/O6gUYmu936osmZlwtmA3FQRAzA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)