UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'gJ6Hq3WyIpaK9SWBUnjNoF6B6tEa5LZ14/zK0vki+qM=' 
WHERE 
  key_id = 'af1511032a51cd0fe193b09f292982129e1b99eec3755619f15b3182172d2637' 
  AND (
    token = 'gJ6Hq3WyIpaK9SWBUnjNoF6B6tEa5LZ14/zK0vki+qM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00044