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

Query time 0.00015