UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'sWt4Hg3ZbdSLVGXgu6Pd76BGHyoI3QIC9wxWQgzWkhI=' 
WHERE 
  key_id = 'd9fd005e3cd3011dc168ea8f3ed5ce219245a2bb0fb95de5240327b285c69c25' 
  AND (
    token = 'sWt4Hg3ZbdSLVGXgu6Pd76BGHyoI3QIC9wxWQgzWkhI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00025