UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '6futa7S9sL/UFc5qzuZbmRrOwt5Hc4OoLO8HJxuMOE0=' 
WHERE 
  key_id = '8e56efc7149a3fcd9f2e21e01622d40632a55221a6835c9eba3d99a2bb3799d1' 
  AND (
    token = '6futa7S9sL/UFc5qzuZbmRrOwt5Hc4OoLO8HJxuMOE0=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00041