UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'QgwRFxJ8JD2fPYc/IIwoCq/7llhCQQBpaUpoP1DBBiA=' 
WHERE 
  key_id = '3490d84188e4ad8b28bd069959f2f7fd2fd83dc6e5c59b08c5abedf2c7610798' 
  AND (
    token = 'QgwRFxJ8JD2fPYc/IIwoCq/7llhCQQBpaUpoP1DBBiA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00041