UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '6NwbKagAcroY0mw5cUUG47N3SU3znbOBL9edLY5XaG8=' 
WHERE 
  key_id = '711a52047f591e75422a0c0bec3207783d5999f1dae2600a9f1ae9315a52bdc0' 
  AND (
    token = '6NwbKagAcroY0mw5cUUG47N3SU3znbOBL9edLY5XaG8=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00011