UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Hs5vwL9Q+YXu+FOqcgALdPR4QGbUWTl1UntGl+nawis=' 
WHERE 
  key_id = '852b8c35faceb1b3ae50afc73ace39b273b19486c4c37f9ac34cd92aba48feff' 
  AND (
    token = 'Hs5vwL9Q+YXu+FOqcgALdPR4QGbUWTl1UntGl+nawis=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00025