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

Query time 0.00021