UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'qSv1E+vJKUOd1C7WhtV8T+RDGhQcIctGtAdhEJs3FkM=' 
WHERE 
  key_id = 'f58d65de71eb22197999de15a3b31603c1a8c331b36ec86c840df598ff17859e' 
  AND (
    token = 'qSv1E+vJKUOd1C7WhtV8T+RDGhQcIctGtAdhEJs3FkM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00025