UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '/2BeI4bw3f1y6seukLUEWHF2+Lid/H2m+gszlGf9Veg=' 
WHERE 
  key_id = 'fe3ca2407e45cce35ca5d33c8f54ed266427ee9b587b8e5e18d91bf30005e1d5' 
  AND (
    token = '/2BeI4bw3f1y6seukLUEWHF2+Lid/H2m+gszlGf9Veg=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00073